package ewan.android.droidjockey;

import android.database.sqlite.SQLiteDatabase;


public class SongInfoStore {
	
	public static final String COLUMN_ID = "_id";
	public static final String COLUMN_TITLE = "title";
	public static final String COLUMN_ARTIST = "artist";
	//public static final String COLUMN_ALBUM = "album";
	public static final String COLUMN_DANCE = "dance";
	public static final String COLUMN_LOUD = "loud";
	public static final String COLUMN_ENERGY = "energy";
	public static final String COLUMN_LENGTH = "length";
	public static final String COLUMN_TEMPO = "tempo";
	public static final String COLUMN_MODE = "mode";
	public static final String COLUMN_TIMESIG = "timesig";
	public static final String COLUMN_TERMS = "terms";
	
	public static final int TABLE_VERSION = 1;
    static final String TABLE_NAME = "songs";
    private static final String TABLE_CREATE = "CREATE TABLE "
    			+ TABLE_NAME 
    			+ "(" 
    			+ COLUMN_ID + " TEXT, " 
    			+ COLUMN_TITLE + " TEXT, "
    			+ COLUMN_ARTIST + " TEXT, "
    			//+ COLUMN_ALBUM + " TEXT, "
    			+ COLUMN_DANCE + " TEXT, "
    			+ COLUMN_LOUD + " TEXT, "
    			+ COLUMN_ENERGY + " TEXT, "
    			+ COLUMN_LENGTH + " TEXT, "
    			+ COLUMN_TEMPO + " TEXT, "
    			+ COLUMN_MODE + " TEXT, "
    			+ COLUMN_TIMESIG + " TEXT, "
    			+ COLUMN_TERMS
    			+ " TEXT"
    			+ ");";
    

    public static void onCreate(SQLiteDatabase db) {
        db.execSQL(TABLE_CREATE);
    }
    
    public static void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion){
    	
    }
    
}